Associating Tables with Handlers
You can describe database tables in an INI control group which begins with DBTable: followed by the database table name. The database table section associates attributes specific to the table. Here is an example:
< DBTable:AppIdx >
DBHandler = ODBC
The DBHANDLER option allows a database table to be mapped by name to the appropriate database handler. No other table-level options are defined at this time.
The system supports multiple simultaneous ODBC connections via different ODBC drivers. This lets you, for instance, connect at the same time to multiple:
- Databases on an SQL server
- Databases on an SQL server and Excel spreadsheet databases
- Access databases and Excel spreadsheet databases
- Access databases
- Excel spreadsheet databases
- Databases for which you have an ODBC-compliant driver
The system does not support multiple different DB2 databases using native DB2 drivers. Support is limited to ODBC-compliant data bases.